package com.itheima.mapper;

import com.itheima.domain.Course;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CourseMapper {
    @Select("SELECT c.* FROM student s,course c,stu_cr sc WHERE sc.sid=s.id AND sc.cid=c.id AND s.id=#{id}")
    List<Course> findByCid(int id);
}
